SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE procedure dbo.[DnnProduct_DeleteFolderPermissionsByUserID]
	@PortalID int,
	@UserID int
AS
	DELETE FROM dbo.DnnProduct_FolderPermission
		FROM dbo.DnnProduct_FolderPermission FP
			INNER JOIN dbo.DnnProduct_Folders AS F ON FP.FolderID  = F.FolderID 
		WHERE F.PortalID = @PortalID
		AND FP.UserID = @UserID
GO
